Show All
CONCATENATE
See Also
Joins several text strings into one text string.
Syntax
CONCATENATE (text1,text2,...)
Text1, text2, ... are 1 to 30 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.
Remarks
The "&" operator can be used instead of CONCATENATE to join text items.
Example
The example may be easier to understand if you copy it to a blank worksheet.
How?
- Create a blank workbook or worksheet.
- Select the example in the Help topic. Do not select the row or column headers.
Selecting an example from Help
- Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.
|
A |
Data |
brook trout |
species |
32 |
Formula |
Description |
=CONCATENATE("Stream population for ",A2," ",A3," is ",A4,"/mile") |
Concatenates a sentence from the data above (Stream population for brook trout species is 32/mile) |
|